Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 1109656 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 93.1 MiB |
| Average record size in memory | 88.0 B |
Variable types
| NUM | 11 |
|---|
Reproduction
| Analysis started | 2020-07-30 22:45:00.990356 |
|---|---|
| Analysis finished | 2020-07-30 22:48:32.306469 |
| Duration | 3 minutes and 31.32 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
year
Real number (ℝ≥0)
| Distinct count | 29 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2002.0 |
|---|---|
| Minimum | 1988 |
| Maximum | 2016 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 1988 |
|---|---|
| 5-th percentile | 1989 |
| Q1 | 1995 |
| median | 2002 |
| Q3 | 2009 |
| 95-th percentile | 2015 |
| Maximum | 2016 |
| Range | 28 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 8.366604035 |
|---|---|
| Coefficient of variation (CV) | 0.004179122895 |
| Kurtosis | -1.202857156 |
| Mean | 2002 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0 |
| Sum | 2221531312 |
| Variance | 70.00006308 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2016 | 38264 | 3.4% | |
| 2001 | 38264 | 3.4% | |
| 1989 | 38264 | 3.4% | |
| 1990 | 38264 | 3.4% | |
| 1991 | 38264 | 3.4% | |
| 1992 | 38264 | 3.4% | |
| 1993 | 38264 | 3.4% | |
| 1994 | 38264 | 3.4% | |
| 1995 | 38264 | 3.4% | |
| 1996 | 38264 | 3.4% | |
| Other values (19) | 727016 | 65.5% |
| Value | Count | Frequency (%) | |
| 1988 | 38264 | 3.4% | |
| 1989 | 38264 | 3.4% | |
| 1990 | 38264 | 3.4% | |
| 1991 | 38264 | 3.4% | |
| 1992 | 38264 | 3.4% |
| Value | Count | Frequency (%) | |
| 2016 | 38264 | 3.4% | |
| 2015 | 38264 | 3.4% | |
| 2014 | 38264 | 3.4% | |
| 2013 | 38264 | 3.4% | |
| 2012 | 38264 | 3.4% |
zipcode
Real number (ℝ≥0)
| Distinct count | 38264 |
|---|---|
| Unique (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49980.3696424838 |
|---|---|
| Minimum | 501 |
| Maximum | 99929 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 501 |
|---|---|
| 5-th percentile | 6349 |
| Q1 | 27309 |
| median | 49331.5 |
| Q3 | 73056.25 |
| 95-th percentile | 95467 |
| Maximum | 99929 |
| Range | 99428 |
| Interquartile range (IQR) | 45747.25 |
Descriptive statistics
| Standard deviation | 27726.5519 |
|---|---|
| Coefficient of variation (CV) | 0.5547488363 |
| Kurtosis | -1.108009529 |
| Mean | 49980.36964 |
| Median Absolute Deviation (MAD) | 23105 |
| Skewness | 0.05135383944 |
| Sum | 5.546101706e+10 |
| Variance | 768761680.1 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 2047 | 29 | < 0.1% | |
| 97634 | 29 | < 0.1% | |
| 34141 | 29 | < 0.1% | |
| 54615 | 29 | < 0.1% | |
| 56662 | 29 | < 0.1% | |
| 50517 | 29 | < 0.1% | |
| 62803 | 29 | < 0.1% | |
| 64850 | 29 | < 0.1% | |
| 58705 | 29 | < 0.1% | |
| 5455 | 29 | < 0.1% | |
| Other values (38254) | 1109366 | > 99.9% |
| Value | Count | Frequency (%) | |
| 501 | 29 | < 0.1% | |
| 1001 | 29 | < 0.1% | |
| 1002 | 29 | < 0.1% | |
| 1003 | 29 | < 0.1% | |
| 1004 | 29 | < 0.1% |
| Value | Count | Frequency (%) | |
| 99929 | 29 | < 0.1% | |
| 99928 | 29 | < 0.1% | |
| 99927 | 29 | < 0.1% | |
| 99926 | 29 | < 0.1% | |
| 99925 | 29 | < 0.1% |
| Distinct count | 754520 |
|---|---|
| Unique (%) | 68.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0004725326979767446 |
|---|---|
| Minimum | 5.6644253e-06 |
| Maximum | 0.3660055999999999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 5.6644253e-06 |
|---|---|
| 5-th percentile | 6.3407526e-05 |
| Q1 | 0.000148677975 |
| median | 0.00025794316 |
| Q3 | 0.00043992483 |
| 95-th percentile | 0.0012042441 |
| Maximum | 0.3660056 |
| Range | 0.3659999356 |
| Interquartile range (IQR) | 0.000291246855 |
Descriptive statistics
| Standard deviation | 0.00170852091 |
|---|---|
| Coefficient of variation (CV) | 3.615667057 |
| Kurtosis | 6978.528196 |
| Mean | 0.000472532698 |
| Median Absolute Deviation (MAD) | 0.00012941556 |
| Skewness | 57.40680154 |
| Sum | 524.3487435 |
| Variance | 2.919043699e-06 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0.00035178766 | 2268 | 0.2% | |
| 0.0005039556 | 2168 | 0.2% | |
| 0.0006497198 | 1668 | 0.2% | |
| 0.00016539691 | 1604 | 0.1% | |
| 0.00017979072 | 1582 | 0.1% | |
| 0.0004910004 | 1565 | 0.1% | |
| 0.0016380961 | 1482 | 0.1% | |
| 0.00023086638 | 1336 | 0.1% | |
| 0.00015789634 | 1333 | 0.1% | |
| 0.00022039752 | 1277 | 0.1% | |
| Other values (754510) | 1093373 | 98.5% |
| Value | Count | Frequency (%) | |
| 5.6644253e-06 | 28 | < 0.1% | |
| 5.6667004e-06 | 27 | < 0.1% | |
| 5.7531083e-06 | 2 | < 0.1% | |
| 6.0264424e-06 | 2 | < 0.1% | |
| 6.440275e-06 | 41 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.3660056 | 1 | < 0.1% | |
| 0.32537597 | 1 | < 0.1% | |
| 0.30560067 | 1 | < 0.1% | |
| 0.28239885 | 1 | < 0.1% | |
| 0.22537343 | 1 | < 0.1% |
SFR_zip
Real number (ℝ≥0)
| Distinct count | 2120 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 31.757130137628238 |
|---|---|
| Minimum | 1.0 |
| Maximum | 6883.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 3.333333333 |
| Q3 | 19 |
| 95-th percentile | 163 |
| Maximum | 6883 |
| Range | 6882 |
| Interquartile range (IQR) | 18 |
Descriptive statistics
| Standard deviation | 88.68840254 |
|---|---|
| Coefficient of variation (CV) | 2.792708351 |
| Kurtosis | 170.9534565 |
| Mean | 31.75713014 |
| Median Absolute Deviation (MAD) | 2.333333333 |
| Skewness | 8.469755335 |
| Sum | 35239490 |
| Variance | 7865.632745 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 317083 | 28.6% | |
| 2 | 112475 | 10.1% | |
| 3 | 65720 | 5.9% | |
| 4 | 46565 | 4.2% | |
| 5 | 35260 | 3.2% | |
| 6 | 28622 | 2.6% | |
| 7 | 23705 | 2.1% | |
| 8 | 19975 | 1.8% | |
| 9 | 17484 | 1.6% | |
| 10 | 15385 | 1.4% | |
| Other values (2110) | 427382 | 38.5% |
| Value | Count | Frequency (%) | |
| 1 | 317083 | 28.6% | |
| 1.038461538 | 2 | < 0.1% | |
| 1.04 | 1 | < 0.1% | |
| 1.041666667 | 1 | < 0.1% | |
| 1.043478261 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6883 | 1 | < 0.1% | |
| 5858 | 1 | < 0.1% | |
| 4307 | 1 | < 0.1% | |
| 4201 | 1 | < 0.1% | |
| 4137 | 1 | < 0.1% |
| Distinct count | 764504 |
|---|---|
| Unique (%) | 68.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.017100710044509703 |
|---|---|
| Minimum | 5.6644253e-06 |
| Maximum | 9.541773 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 5.6644253e-06 |
|---|---|
| 5-th percentile | 8.054863e-05 |
| Q1 | 0.00030280277 |
| median | 0.001045424087 |
| Q3 | 0.006675634675 |
| 95-th percentile | 0.0723692975 |
| Maximum | 9.541773 |
| Range | 9.541767336 |
| Interquartile range (IQR) | 0.006372831905 |
Descriptive statistics
| Standard deviation | 0.0879202355 |
|---|---|
| Coefficient of variation (CV) | 5.141320757 |
| Kurtosis | 1248.442109 |
| Mean | 0.01710071004 |
| Median Absolute Deviation (MAD) | 0.0009196725175 |
| Skewness | 25.46036202 |
| Sum | 18975.90551 |
| Variance | 0.007729967811 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0.00035178766 | 2145 | 0.2% | |
| 0.0005039556 | 2017 | 0.2% | |
| 0.0006497198 | 1574 | 0.1% | |
| 0.00017979072 | 1510 | 0.1% | |
| 0.00016539691 | 1507 | 0.1% | |
| 0.0004910004 | 1478 | 0.1% | |
| 0.0016380961 | 1362 | 0.1% | |
| 0.00015789634 | 1287 | 0.1% | |
| 0.00023086638 | 1219 | 0.1% | |
| 0.00022039752 | 1182 | 0.1% | |
| Other values (764494) | 1094375 | 98.6% |
| Value | Count | Frequency (%) | |
| 5.6644253e-06 | 28 | < 0.1% | |
| 5.6667004e-06 | 27 | < 0.1% | |
| 5.7531083e-06 | 2 | < 0.1% | |
| 6.0264424e-06 | 2 | < 0.1% | |
| 6.440275e-06 | 41 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9.541773 | 1 | < 0.1% | |
| 9.173729 | 1 | < 0.1% | |
| 8.419393 | 1 | < 0.1% | |
| 7.458536 | 1 | < 0.1% | |
| 7.4182096 | 1 | < 0.1% |
| Distinct count | 324109 |
|---|---|
| Unique (%) | 29.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0005084221387123552 |
|---|---|
| Minimum | 1.1497502e-05 |
| Maximum | 0.1535093703 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 1.1497502e-05 |
|---|---|
| 5-th percentile | 0.0001150341 |
| Q1 | 0.0002171501586 |
| median | 0.0003395700525 |
| Q3 | 0.000528607785 |
| 95-th percentile | 0.00143251701 |
| Maximum | 0.1535093703 |
| Range | 0.1534978728 |
| Interquartile range (IQR) | 0.0003114576264 |
Descriptive statistics
| Standard deviation | 0.0008826023985 |
|---|---|
| Coefficient of variation (CV) | 1.735963742 |
| Kurtosis | 3249.737802 |
| Mean | 0.0005084221387 |
| Median Absolute Deviation (MAD) | 0.0001404248125 |
| Skewness | 36.11887258 |
| Sum | 564.1736768 |
| Variance | 7.789869938e-07 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0.0006468147 | 1054 | 0.1% | |
| 0.00044274333 | 917 | 0.1% | |
| 0.00022086225 | 917 | 0.1% | |
| 0.00041259924 | 917 | 0.1% | |
| 0.0002870331 | 917 | 0.1% | |
| 0.0003858068 | 917 | 0.1% | |
| 0.00028066424 | 917 | 0.1% | |
| 0.00020755648 | 917 | 0.1% | |
| 0.00043378497 | 917 | 0.1% | |
| 0.00045508775 | 917 | 0.1% | |
| Other values (324099) | 1100349 | 99.2% |
| Value | Count | Frequency (%) | |
| 1.1497502e-05 | 1 | < 0.1% | |
| 1.41354085e-05 | 12 | < 0.1% | |
| 1.7317287e-05 | 7 | < 0.1% | |
| 1.8140032e-05 | 4 | < 0.1% | |
| 2.0291376e-05 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.1535093703 | 1 | < 0.1% | |
| 0.1415600972 | 1 | < 0.1% | |
| 0.1139731482 | 1 | < 0.1% | |
| 0.1100654443 | 1 | < 0.1% | |
| 0.1024380301 | 1 | < 0.1% |
SFR_MSA
Real number (ℝ≥0)
| Distinct count | 83153 |
|---|---|
| Unique (%) | 7.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11655.35467771093 |
|---|---|
| Minimum | 1.0 |
| Maximum | 165622.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 37 |
| Q1 | 340 |
| median | 2775.583333 |
| Q3 | 13295 |
| 95-th percentile | 55456 |
| Maximum | 165622 |
| Range | 165621 |
| Interquartile range (IQR) | 12955 |
Descriptive statistics
| Standard deviation | 20520.71049 |
|---|---|
| Coefficient of variation (CV) | 1.760625143 |
| Kurtosis | 11.90652233 |
| Mean | 11655.35468 |
| Median Absolute Deviation (MAD) | 2693.916667 |
| Skewness | 3.068453379 |
| Sum | 1.293343425e+10 |
| Variance | 421099559.2 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 1 | 7515 | 0.7% | |
| 2 | 1929 | 0.2% | |
| 50318 | 1834 | 0.2% | |
| 42 | 1722 | 0.2% | |
| 14 | 1696 | 0.2% | |
| 5 | 1685 | 0.2% | |
| 10 | 1540 | 0.1% | |
| 21 | 1535 | 0.1% | |
| 4 | 1528 | 0.1% | |
| 69 | 1527 | 0.1% | |
| Other values (83143) | 1087145 | 98.0% |
| Value | Count | Frequency (%) | |
| 1 | 7515 | 0.7% | |
| 1.2 | 5 | < 0.1% | |
| 1.333333333 | 1 | < 0.1% | |
| 1.333333333 | 22 | < 0.1% | |
| 1.4 | 5 | < 0.1% |
| Value | Count | Frequency (%) | |
| 165622 | 1 | < 0.1% | |
| 165573.5 | 1 | < 0.1% | |
| 165530.5 | 1 | < 0.1% | |
| 165462 | 1 | < 0.1% | |
| 165426.5 | 1 | < 0.1% |
RECPI_MSA
Real number (ℝ≥0)
| Distinct count | 327130 |
|---|---|
| Unique (%) | 29.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.114618631919836 |
|---|---|
| Minimum | 1.1497502e-05 |
| Maximum | 223.24586300000004 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 1.1497502e-05 |
|---|---|
| 5-th percentile | 0.010554047 |
| Q1 | 0.10644382 |
| median | 0.8754009302 |
| Q3 | 6.194858729 |
| 95-th percentile | 35.49057687 |
| Maximum | 223.245863 |
| Range | 223.2458515 |
| Interquartile range (IQR) | 6.088414909 |
Descriptive statistics
| Standard deviation | 22.52159884 |
|---|---|
| Coefficient of variation (CV) | 2.77543528 |
| Kurtosis | 35.94229434 |
| Mean | 8.114618632 |
| Median Absolute Deviation (MAD) | 0.8577554892 |
| Skewness | 5.544674165 |
| Sum | 9004435.253 |
| Variance | 507.2224142 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0.0006468147 | 1054 | 0.1% | |
| 13.122136 | 917 | 0.1% | |
| 13.04385 | 917 | 0.1% | |
| 11.020869 | 917 | 0.1% | |
| 13.529889 | 917 | 0.1% | |
| 13.982568 | 917 | 0.1% | |
| 13.397815 | 917 | 0.1% | |
| 10.166127 | 917 | 0.1% | |
| 16.727505 | 917 | 0.1% | |
| 13.33358 | 917 | 0.1% | |
| Other values (327120) | 1100349 | 99.2% |
| Value | Count | Frequency (%) | |
| 1.1497502e-05 | 1 | < 0.1% | |
| 1.7317287e-05 | 7 | < 0.1% | |
| 1.8140032e-05 | 4 | < 0.1% | |
| 2.0291376e-05 | 1 | < 0.1% | |
| 2.0864842e-05 | 14 | < 0.1% |
| Value | Count | Frequency (%) | |
| 223.245863 | 1 | < 0.1% | |
| 222.7909033 | 1 | < 0.1% | |
| 222.4541515 | 1 | < 0.1% | |
| 222.4328484 | 1 | < 0.1% | |
| 222.3881199 | 1 | < 0.1% |
EQI_state
Real number (ℝ≥0)
| Distinct count | 35824 |
|---|---|
| Unique (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0005543055481338894 |
|---|---|
| Minimum | 7.426358e-05 |
| Maximum | 0.0037453347 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 7.426358e-05 |
|---|---|
| 5-th percentile | 0.00014480183 |
| Q1 | 0.00026605063 |
| median | 0.00040966412 |
| Q3 | 0.0005995629 |
| 95-th percentile | 0.0018229785 |
| Maximum | 0.0037453347 |
| Range | 0.00367107112 |
| Interquartile range (IQR) | 0.00033351227 |
Descriptive statistics
| Standard deviation | 0.0004874645425 |
|---|---|
| Coefficient of variation (CV) | 0.8794148716 |
| Kurtosis | 5.678371162 |
| Mean | 0.0005543055481 |
| Median Absolute Deviation (MAD) | 0.0001568573825 |
| Skewness | 2.323661262 |
| Sum | 615.0884773 |
| Variance | 2.376216802e-07 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 0.0003829586 | 2797 | 0.3% | |
| 0.0017275866 | 2392 | 0.2% | |
| 0.0006546165 | 2389 | 0.2% | |
| 0.0020422665 | 2349 | 0.2% | |
| 0.0007603918 | 2346 | 0.2% | |
| 0.0010313498 | 2326 | 0.2% | |
| 0.0019577374 | 2326 | 0.2% | |
| 0.0017248512 | 2317 | 0.2% | |
| 0.002142746 | 2317 | 0.2% | |
| 0.0017149167 | 2315 | 0.2% | |
| Other values (35814) | 1085782 | 97.8% |
| Value | Count | Frequency (%) | |
| 7.426358e-05 | 698 | 0.1% | |
| 7.625624e-05 | 30 | < 0.1% | |
| 7.660029333e-05 | 11 | < 0.1% | |
| 7.660762583e-05 | 5 | < 0.1% | |
| 7.679038286e-05 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.0037453347 | 620 | 0.1% | |
| 0.003556253525 | 1 | < 0.1% | |
| 0.003531739567 | 1 | < 0.1% | |
| 0.003469798671 | 1 | < 0.1% | |
| 0.003439991817 | 3 | < 0.1% |
SFR_state
Real number (ℝ≥0)
| Distinct count | 34851 |
|---|---|
| Unique (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44199.77196491525 |
|---|---|
| Minimum | 40.0 |
| Maximum | 330536.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 40 |
|---|---|
| 5-th percentile | 3167.707692 |
| Q1 | 11527 |
| median | 27032 |
| Q3 | 57480 |
| 95-th percentile | 144758 |
| Maximum | 330536 |
| Range | 330496 |
| Interquartile range (IQR) | 45953 |
Descriptive statistics
| Standard deviation | 50037.81531 |
|---|---|
| Coefficient of variation (CV) | 1.13208311 |
| Kurtosis | 6.736711374 |
| Mean | 44199.77196 |
| Median Absolute Deviation (MAD) | 18608.33333 |
| Skewness | 2.332689413 |
| Sum | 4.904654216e+10 |
| Variance | 2503782961 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 113623 | 3611 | 0.3% | |
| 73716 | 2797 | 0.3% | |
| 18675 | 2513 | 0.2% | |
| 171222 | 2392 | 0.2% | |
| 119626 | 2389 | 0.2% | |
| 168977 | 2349 | 0.2% | |
| 92187 | 2346 | 0.2% | |
| 156007 | 2326 | 0.2% | |
| 57601 | 2326 | 0.2% | |
| 185741 | 2317 | 0.2% | |
| Other values (34841) | 1084290 | 97.7% |
| Value | Count | Frequency (%) | |
| 40 | 211 | < 0.1% | |
| 63 | 148 | < 0.1% | |
| 65 | 117 | < 0.1% | |
| 67 | 16 | < 0.1% | |
| 71 | 150 | < 0.1% |
| Value | Count | Frequency (%) | |
| 330536 | 1286 | 0.1% | |
| 322793.6667 | 1 | < 0.1% | |
| 315234.1429 | 1 | < 0.1% | |
| 315051.3333 | 1 | < 0.1% | |
| 314672 | 6 | < 0.1% |
RECPI_state
Real number (ℝ≥0)
| Distinct count | 35822 |
|---|---|
| Unique (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30.203583309878322 |
|---|---|
| Minimum | 0.01783298 |
| Maximum | 442.21994000000007 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 8.5 MiB |
Quantile statistics
| Minimum | 0.01783298 |
|---|---|
| 5-th percentile | 0.67425174 |
| Q1 | 4.184579 |
| median | 11.849025 |
| Q3 | 26.99141 |
| 95-th percentile | 96.0401 |
| Maximum | 442.21994 |
| Range | 442.202107 |
| Interquartile range (IQR) | 22.806831 |
Descriptive statistics
| Standard deviation | 59.33080148 |
|---|---|
| Coefficient of variation (CV) | 1.964362999 |
| Kurtosis | 18.82629165 |
| Mean | 30.20358331 |
| Median Absolute Deviation (MAD) | 9.3076 |
| Skewness | 4.114851461 |
| Sum | 33515587.44 |
| Variance | 3520.144005 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 28.230175 | 2797 | 0.3% | |
| 295.80084 | 2392 | 0.2% | |
| 78.30916 | 2389 | 0.2% | |
| 345.09607 | 2349 | 0.2% | |
| 70.09824 | 2346 | 0.2% | |
| 305.42075 | 2326 | 0.2% | |
| 59.406776 | 2326 | 0.2% | |
| 268.46793 | 2317 | 0.2% | |
| 397.9958 | 2317 | 0.2% | |
| 223.54796 | 2315 | 0.2% | |
| Other values (35812) | 1085782 | 97.8% |
| Value | Count | Frequency (%) | |
| 0.01783298 | 58 | < 0.1% | |
| 0.022516895 | 1 | < 0.1% | |
| 0.02271251667 | 2 | < 0.1% | |
| 0.023547488 | 1 | < 0.1% | |
| 0.02363899875 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 442.21994 | 2269 | 0.2% | |
| 425.9111556 | 1 | < 0.1% | |
| 425.087204 | 2 | < 0.1% | |
| 424.64432 | 2253 | 0.2% | |
| 424.1752289 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| year | zipcode | EQI_zip | SFR_zip | RECPI_zip | EQI_MSA | SFR_MSA | RECPI_MSA | EQI_state | SFR_state | RECPI_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1988 | 1001 | 0.000815 | 48.0 | 0.039108 | 0.001021 | 1235.0 | 1.260888 | 0.001476 | 17558.0 | 25.921940 |
| 1 | 1989 | 1001 | 0.001116 | 44.0 | 0.049100 | 0.001168 | 1049.0 | 1.225384 | 0.001751 | 15343.0 | 26.866861 |
| 2 | 1990 | 1001 | 0.001629 | 45.0 | 0.073317 | 0.001243 | 841.0 | 1.045161 | 0.001857 | 13556.0 | 25.172453 |
| 3 | 1991 | 1001 | 0.000826 | 27.0 | 0.022298 | 0.001375 | 714.0 | 0.981724 | 0.001823 | 12798.0 | 23.330479 |
| 4 | 1992 | 1001 | 0.002216 | 22.0 | 0.048744 | 0.001549 | 760.0 | 1.176877 | 0.002111 | 13289.0 | 28.052156 |
| 5 | 1993 | 1001 | 0.000827 | 27.0 | 0.022334 | 0.001266 | 824.0 | 1.043205 | 0.002057 | 14110.0 | 29.028145 |
| 6 | 1994 | 1001 | 0.004772 | 33.0 | 0.157489 | 0.001394 | 804.0 | 1.121105 | 0.001996 | 14843.0 | 29.624968 |
| 7 | 1995 | 1001 | 0.001065 | 23.0 | 0.024496 | 0.001667 | 817.0 | 1.362325 | 0.002023 | 15180.0 | 30.703022 |
| 8 | 1996 | 1001 | 0.001971 | 29.0 | 0.057166 | 0.001361 | 884.0 | 1.203223 | 0.002326 | 16520.0 | 38.430626 |
| 9 | 1997 | 1001 | 0.000840 | 42.0 | 0.035283 | 0.001233 | 902.0 | 1.112023 | 0.002386 | 17254.0 | 41.174500 |
Last rows
| year | zipcode | EQI_zip | SFR_zip | RECPI_zip | EQI_MSA | SFR_MSA | RECPI_MSA | EQI_state | SFR_state | RECPI_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1109646 | 2007 | 99626 | 0.000018 | 1.0 | 0.000018 | 0.00005 | 1924.0 | 0.15751 | 0.000082 | 3847.0 | 0.315002 |
| 1109647 | 2008 | 99626 | 0.000018 | 1.0 | 0.000018 | 0.00005 | 1924.0 | 0.15751 | 0.000082 | 3847.0 | 0.315002 |
| 1109648 | 2009 | 99626 | 0.000018 | 1.0 | 0.000018 | 0.00005 | 1924.0 | 0.15751 | 0.000082 | 3847.0 | 0.315002 |
| 1109649 | 2010 | 99626 | 0.000018 | 1.0 | 0.000018 | 0.00005 | 1924.0 | 0.15751 | 0.000082 | 3847.0 | 0.315002 |
| 1109650 | 2011 | 99626 | 0.000018 | 1.0 | 0.000018 | 0.00005 | 1924.0 | 0.15751 | 0.000082 | 3847.0 | 0.315002 |
| 1109651 | 2012 | 99626 | 0.000018 | 1.0 | 0.000018 | 0.00005 | 1924.0 | 0.15751 | 0.000082 | 3847.0 | 0.315002 |
| 1109652 | 2013 | 99626 | 0.000018 | 1.0 | 0.000018 | 0.00005 | 1924.0 | 0.15751 | 0.000082 | 3847.0 | 0.315002 |
| 1109653 | 2014 | 99626 | 0.000018 | 1.0 | 0.000018 | 0.00005 | 1924.0 | 0.15751 | 0.000082 | 3847.0 | 0.315002 |
| 1109654 | 2015 | 99626 | 0.000018 | 1.0 | 0.000018 | 0.00005 | 1924.0 | 0.15751 | 0.000082 | 3847.0 | 0.315002 |
| 1109655 | 2016 | 99626 | 0.000018 | 1.0 | 0.000018 | 0.00005 | 1924.0 | 0.15751 | 0.000082 | 3847.0 | 0.315002 |